
	
/****** Object:  Stored Procedure [sapro].QuangCaoUpdate    Script Date: Thursday, March 18, 2010 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spQuangCaoUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [sapro].[spQuangCaoUpdate]
GO
			
	
	

	
/******************************************************************************
**		File: 
**		Name: [sapro].spQuangCaoUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 3/18/2010 5:04:38 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE [sapro].spQuangCaoUpdate
	@MaQuangCao int, 
	@TenQuangCao nchar(10), 
	@NoiDung nchar(10), 
	@ChiTiet nchar(10), 
	@ThuocDanhMuc int 
AS

UPDATE [sapro].[QuangCao] SET
	[TenQuangCao] = @TenQuangCao,
	[NoiDung] = @NoiDung,
	[ChiTiet] = @ChiTiet,
	[ThuocDanhMuc] = @ThuocDanhMuc
WHERE
	[MaQuangCao] = @MaQuangCao

GO

